﻿using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;

namespace DataModels.Models
{
    public class MCForm
    {
        [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int Id { get; set; }

        [ForeignKey("Facility"), StringLength(50)]
        public string FacilityCode { get; set; }
        public Facility Facility { get; set; }

        public System.DateTime ReportDate { get; set; }
        //public bool LessThan20 { get; set; }

        [Required, StringLength(7)]
        public string Quarter { get; set; }

        [StringLength(1000)]
        public string Comments { get; set; }

        [DatabaseGenerated(DatabaseGeneratedOption.Computed)]
        public Nullable<int> Year { get; set; }

        [DatabaseGenerated(DatabaseGeneratedOption.Computed)]
        public Nullable<int> Month { get; set; }

        public int MC01 { get; set; }
        public int MC02 { get; set; }
        public int MC03 { get; set; }
        public int MC04 { get; set; }
        public int MC05 { get; set; }
        public int MC06 { get; set; }
        public int MC07 { get; set; }
        public int MC08 { get; set; }
        public int MC09 { get; set; }
        public int MC10 { get; set; }
        public int MC11 { get; set; }
        public int MC12 { get; set; }
        public int MC13 { get; set; }
        public int MC14 { get; set; }
        public int MC15 { get; set; }
        public int MC16 { get; set; }
        public int MC17 { get; set; }
        public int MC18 { get; set; }
        public int MC19 { get; set; }
    }
}
